﻿CREATE TABLE [dbo].[Subscriber]
(
[SubscriberIDKey] [int] NOT NULL IDENTITY(1, 1),
[HierarchicalIDNumber] [nvarchar] (12) NULL,
[HierarchicalParentIDNumber] [nvarchar] (12) NULL,
[HierarchicalLevelCode] [nvarchar] (2) NULL,
[HierarchicalChildCode] [nvarchar] (1) NULL,
[PayerResponsibilitySequenceNumberCode] [nvarchar] (1) NULL,
[IndividualRelationshipCode] [nvarchar] (2) NULL,
[InsuredGroupOrPolicyNumber] [nvarchar] (30) NULL,
[InsuredGroupName] [nvarchar] (60) NULL,
[ClaimFilingIndicatorCode] [nvarchar] (2) NULL,
[EntityIdentifierCode] [nvarchar] (3) NULL,
[EntityTypeQualifier] [nvarchar] (1) NULL,
[SubscriberLastOrOrganizationName] [nvarchar] (35) NULL,
[SubscriberFirstName] [nvarchar] (25) NULL,
[SubscriberMiddleName] [nvarchar] (25) NULL,
[SubscriberNameSuffix] [nvarchar] (10) NULL,
[IdentificationCodeQualifier] [nvarchar] (2) NULL,
[SubscriberPrimaryIdentifier] [nvarchar] (80) NULL,
[SubscriberAddressLine1] [nvarchar] (55) NULL,
[SubscriberAddressLine2] [nvarchar] (55) NULL,
[SubscriberCityName] [nvarchar] (30) NULL,
[SubscriberStateCode] [nvarchar] (2) NULL,
[SubscriberPostalCode] [nvarchar] (15) NULL,
[SubscriberCountryCode] [nvarchar] (3) NULL,
[SubscriberGenderCode] [nvarchar] (1) NULL,
[SubscriberBirthDate] [nvarchar] (50) NULL,
[SubscriberSupplementalIdentifier] [nvarchar] (30) NULL,
[SubscriberPropertyCasualtyClaimNumber] [nvarchar] (30) NULL,
[SubscriberCCEntityIdentiferCode] [nvarchar] (3) NULL,
[SubscriberCCEntityTypeQualifier] [nvarchar] (1) NULL,
[CreditOrDebitCardHolderLastOrOrganizationalName] [nvarchar] (30) NULL,
[CreditOrDebitCardHolderFirstName] [nvarchar] (25) NULL,
[CreditOrDebitCardHolderMiddleName] [nvarchar] (25) NULL,
[CreditOrDebitCardHolderNameSuffix] [nvarchar] (10) NULL,
[CreditOrDebitIdentificationCodeQualifier] [nvarchar] (2) NULL,
[CreditOrDebitCardNumber] [nvarchar] (80) NULL,
[CreditOrDebitReferenceIdentificationQualifier] [nvarchar] (3) NULL,
[CreditOrDebitCardAuthorizationNumber] [nvarchar] (30) NULL,
[PayerEntityIdentifierCode] [nvarchar] (3) NULL,
[PayerEntityTypeQualifier] [nvarchar] (1) NULL,
[PayerLastOrOrganizationName] [nvarchar] (35) NULL,
[PayerIdentificationCodeQualifier] [nvarchar] (2) NULL,
[PayerIdentificationCode] [nvarchar] (80) NULL,
[PayerAddressLine1] [nvarchar] (55) NULL,
[PayerAddressLine2] [nvarchar] (55) NULL,
[PayerCityName] [nvarchar] (30) NULL,
[PayerStateCode] [nvarchar] (2) NULL,
[PayerPostalCode] [nvarchar] (15) NULL,
[PayerCountryCode] [nvarchar] (3) NULL,
[PayerReferenceIdQualifier] [nvarchar] (3) NULL,
[PayerAdditionalIdentifier] [nvarchar] (30) NULL,
[EDIMessageType] [nvarchar] (50) NULL,
[GroupControlNumber] [nvarchar] (9) NULL,
[TransactionSetControlNumber] [nvarchar] (9) NULL,
[InterchangeControlNumber] [nvarchar] (9) NULL,
[TransactionSetIDKey] [int] NULL,
[BTSMessageID] [nvarchar] (100) NULL,
[BTSInterchangeID] [nvarchar] (100) NULL
) ON [PRIMARY]


